SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419702 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419702 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459242,1009647,550798,800289,533401,453796,103998,480807,536015,870655,616441,643314,292596,209053,268616,433766,781185,100390,81579,278925,147734,364025,407730,259287,110115,772327,484938,85522,461245,836023,672671,955015,2748,153329,780082,227515,167579,437410,584983,401427,403923,3547,189365,137482,541537,1028185,966389,192485,76373,406624,564727,947376,1028982,397380,360536,571782,232630,214281,931587,977082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419702 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419702 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]