SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001857s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517121 LIMIT 1 [ RunTime:0.001525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517121 [ RunTime:0.002984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039563,242625,996905,561967,519940,842826,898806,99079,778007,715819,979205,686021,999527,98799,898808,7882,76492,561173,61008,428007,606955,197171,893906,195391,863399,485120,564448,116828,910037,548052,666364,640452,1303,413514,674711,283058,139393,737776,941404,643967,586128,771133,1037393,414448,749549,186547,279336,948369,52204,199430,499777,554516,151080,21762,979632,880841,609554,310131,36216,179302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]