SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559473 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559473 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120612,729238,641127,218919,751360,345366,51577,209190,499624,449357,991804,378758,690041,974474,737933,902662,379729,578705,767540,802584,709655,234199,856101,82250,187834,1006141,375099,540552,993442,991989,981347,798553,490843,636564,989979,574558,291668,587223,277460,559068,363084,630078,159412,190267,447560,450080,895809,1045339,551332,167353,769644,645613,157277,523446,370353,842979,592132,485916,828651,74754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]