SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018032 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018032 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114365,542668,919526,165241,213434,431886,950425,121121,336432,10502,51651,194159,51961,482584,284401,706136,157717,146425,1000247,464082,315085,12430,811380,837113,657847,178251,298469,935823,802369,64821,750572,126889,435862,696588,735244,657288,378642,212812,1047711,246832,801098,915553,507485,999748,86893,1046218,128205,888795,500493,742838,940735,981282,730294,519359,578857,720158,940922,994630,612117,311649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]