SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507722 LIMIT 1 [ RunTime:0.000543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507722 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368244,367406,614012,300077,825146,535066,956980,143294,762131,758356,51193,252681,378745,639437,62954,978510,522833,187048,323215,547945,495187,869399,806489,742035,676572,624571,933038,958136,978118,639861,966181,567830,580469,897114,275169,287919,450853,837058,213138,102209,70509,541986,837787,712149,764140,55005,260320,702573,281004,696200,806496,1007142,557770,661763,1005762,802501,990851,637890,1021356,759186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]