SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035310 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035310 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42649,218757,726861,479662,949630,1037988,525929,191210,862705,124162,6014,886601,955837,659009,708670,207779,819640,750265,85211,612783,1017252,786380,714824,457350,245619,523474,760740,264242,625767,341190,243270,120746,140358,652270,703034,669114,908922,962485,128580,524119,177676,82932,302163,588153,830481,144020,512744,453708,200937,820545,314841,1012366,169818,542031,641666,282545,531856,565926,53277,639983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]