SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011319 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011319 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329598,231048,89927,358671,69343,848049,932237,697654,903593,490418,551956,437948,826927,922531,81763,156164,997542,892900,49483,493019,196508,185757,696096,688303,220022,697476,493252,174833,862799,804803,261198,34324,632096,316778,602213,352441,238584,501341,628329,1031423,545935,451793,313648,77479,799039,1017773,609322,85556,145178,971568,560027,978548,544640,383182,835627,1006022,962682,386803,646105,482838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]