SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403706 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403706 [ RunTime:0.004073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702273,616427,279046,235655,539757,521551,265677,549923,595962,700095,157842,571140,307250,750657,37528,781412,74589,954144,220253,622203,769074,462459,411380,92630,644345,451381,332468,854021,742032,48502,647486,488109,171443,867283,1017437,236695,361976,234234,688339,889272,537740,649075,254790,486481,540330,734497,698160,117069,595031,897839,617526,78974,152250,1034368,463850,789289,287692,632379,81201,856390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]