SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314552 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314552 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046137,318589,223218,803814,449245,321208,639076,767259,685431,574743,295849,980817,951249,549029,819380,329294,805523,956229,890819,768239,1013879,185137,408144,566584,112594,272634,297237,914840,676610,997485,330111,527822,911396,258936,946069,947340,669423,186919,745578,787649,1025306,632408,969314,22714,776334,414598,65366,493145,127544,362968,634338,1012132,269658,136486,813353,1000568,77602,677091,436290,490471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]