SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501432 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501432 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473186,1030852,382104,240129,258514,1001478,724515,995058,798630,438027,898103,608768,305837,598214,521387,466563,137282,768945,248933,725546,480875,511514,711193,642833,309352,179514,619624,656212,89189,680557,576008,81682,84871,525286,824624,232626,778545,41205,693505,158671,247031,287642,1039481,574226,1038091,413889,924534,964606,799421,229200,10198,651035,447062,893269,776646,739493,504828,609324,685086,1027511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]