SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44053 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44053 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526826,739133,681495,611561,315944,501704,148358,108077,459670,637528,908701,406852,317168,930791,478172,650822,129335,559218,469879,378099,780927,593532,392669,308034,542353,100872,658503,357747,248511,449984,996038,756120,94008,389856,613179,89489,146977,938314,379350,326859,690198,32861,411388,763479,320747,291004,109464,355987,634912,712773,895030,316331,316631,738509,231172,561184,588544,1008753,254880,269558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]