SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011540 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011540 [ RunTime:0.004594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376317,881781,945459,453041,930355,66599,888890,165475,761010,472523,819763,316955,655108,9041,729486,862830,686811,605631,691577,279229,898817,802358,609166,55619,486960,432480,628100,847981,143561,146840,155168,178446,103505,1005172,143923,657771,989931,482316,207351,227054,65993,64728,565658,1033573,710195,1018358,502537,1036195,770632,300155,948211,601340,41768,852275,454911,127760,934057,994220,371439,515022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]