SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405118 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405118 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356472,151235,470461,135048,432741,97821,144038,323345,603542,251365,659909,779946,209391,172908,625276,782480,333120,5126,985571,871840,749924,545695,245383,950574,801527,909954,718997,459015,1040060,446317,1017700,614592,337998,994949,517624,464536,823499,565811,341708,618343,344952,1034733,491095,874524,354110,303549,238967,599827,875288,151215,864422,115156,46064,676198,644199,436403,504310,792268,650802,787712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]