SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002944s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557409 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557409 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187895,191762,648452,1017995,666894,862174,941167,442239,75171,667612,785464,59818,205550,562698,926040,671067,533288,201840,148316,812469,541956,57864,142189,336096,623936,956314,928381,632119,703643,833586,946996,106152,119381,517233,141926,95009,912595,725632,16277,529941,93558,727519,944039,783976,496987,798323,746271,817276,972914,75895,37178,480465,263822,229149,468668,981007,891778,954304,745539,606883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]