SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472523 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472523 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948771,3549,835652,352324,761763,572524,865044,927954,768162,1037845,804906,457419,709418,450772,140045,388165,130766,108385,523084,1038677,290727,979841,265809,587701,651003,998781,893951,945266,617290,257253,312783,762405,808732,498955,580172,958782,417023,892829,705384,600058,783265,684894,506209,737314,1032167,110185,254107,1045324,502096,353251,303671,121680,144824,303405,956883,543521,686518,57069,735873,965823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]