SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401192 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401192 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733181,124722,1013553,219750,235964,914149,59018,593347,145914,559629,753925,1018724,261715,995450,852500,986169,386672,1011860,25555,377753,101021,817269,359221,354944,290145,775670,250204,1037639,823650,733456,837286,78470,201373,169648,868194,588913,157965,186088,343484,312789,1044867,810493,285843,775022,194842,336763,481551,186729,947067,108142,833758,313566,156597,604782,577916,117475,654294,882665,427196,490129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]