SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 749824 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 749824 [ RunTime:0.004225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455204,26235,837140,207236,786015,1013205,553150,728838,809411,469396,480841,1011647,404163,44418,961523,1005407,693838,142572,1018008,927797,261909,1025362,982846,695430,318159,245656,56082,790114,231974,876801,30404,654021,913841,200062,360731,532839,136826,440128,762784,724751,126496,203699,114530,490942,402542,766882,220504,73983,805541,605565,416225,429111,717813,629102,874362,10488,375276,476992,965002,795920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 749824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 749824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]