SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542930 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542930 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503824,302597,459074,941091,117257,130736,628341,297327,302316,403170,284481,788220,221366,27252,747130,281652,434320,339112,751570,905218,341823,507214,14977,732750,435002,727468,81943,585703,936680,173938,421269,516784,740711,1009996,930453,446168,552307,930611,144062,418896,748185,795409,1018710,721165,321915,571664,213211,691080,544365,616936,428482,443232,277133,196561,372732,1004206,30418,876475,566771,329028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001334s ]