SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108051 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108051 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67494,548280,973387,1039591,552353,128213,767632,673465,570048,109293,726507,320781,7356,150951,600352,936181,848033,709952,878832,959340,317204,60761,680318,371084,80045,797009,576452,225922,709465,57866,119696,49439,539341,37240,742473,542568,582276,575940,906500,309076,330682,607793,231205,470521,356637,775709,178574,199165,516948,427338,810244,1045478,829083,958998,47942,728433,799803,996268,632081,510846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]