SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52988 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52988 [ RunTime:0.004057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620984,36922,1034425,137866,618985,212408,572448,477037,401113,275926,378488,522740,471813,116483,46281,376684,1013190,902634,287632,572146,789383,391464,584031,499470,895627,503779,794619,181543,271401,469197,1017587,438483,912463,463683,668785,598761,876937,651575,328633,273800,2165,328466,442868,970240,226910,319691,583853,524350,215911,431319,541109,555608,994963,477765,912684,584381,115435,221511,605284,601917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]