SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5323 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5323 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383866,341484,515264,763297,728424,294230,219964,781409,795128,687492,573596,1039564,1019550,617384,846753,481241,750853,157509,947350,339406,626517,819302,823248,155358,809060,603029,435728,796268,8188,1005639,368485,652634,1035671,39189,928076,516516,79950,283952,979934,134674,921420,115374,811981,618316,53652,1015107,474044,361939,994051,548530,647534,465541,1010989,227938,560889,40057,944497,687629,768767,596215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003270s ]