SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570515 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570515 [ RunTime:0.003127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625089,179122,1006197,237799,716303,718821,492875,750713,445951,301278,307415,148799,819376,428951,242928,326122,1034474,376972,531637,1040595,802079,950541,927481,15124,339019,400905,884534,367711,53422,769692,78091,379689,1048333,783735,495527,429140,650307,688645,535347,598432,694410,1033013,610433,675991,191059,440414,581678,289582,502887,557046,26507,601714,612653,602396,105957,490281,848279,728200,538417,478017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001826s ]