SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535513 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535513 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197269,574196,933676,510370,870724,319830,878521,208322,121603,881127,52820,994080,226497,1007319,369943,982572,224088,445632,781316,574688,187337,208473,217111,302863,64678,573882,623773,783264,696804,62597,570269,684773,289244,258610,209177,933759,835323,671976,749997,668689,656854,395364,992110,215768,516218,84296,627906,880974,351328,514621,619098,663334,607816,74331,130004,420750,889271,292554,320066,253409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]