SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501856 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501856 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551699,547252,936888,68114,876666,438390,228769,957824,181771,549059,393369,992348,317571,488730,588810,441122,711376,101924,911831,237156,88570,1041637,627194,216397,1028970,48983,882942,707864,467576,689594,67971,244715,684401,450018,387315,940610,608889,1033293,124845,903149,724573,892926,653652,189317,724987,215327,618892,1016565,817335,442449,610454,720467,598099,426385,754725,753482,621648,940143,95623,1033502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]