SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153974 LIMIT 1 [ RunTime:0.003983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153974 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500935,1019292,839723,111189,636991,520537,1022703,454004,139323,630685,1026968,363053,106218,264747,88768,425770,926325,607049,834792,943936,164874,985077,399042,320577,377288,137339,553117,142160,598449,630770,937485,539213,1020916,964268,484958,723257,71480,809414,730042,547804,141037,161487,1029628,877589,178747,476124,557790,1007439,189979,114409,302815,91323,328519,1620,706094,431963,240313,908903,567259,439816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]