SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242414 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242414 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619124,823703,717444,985024,649151,110499,886027,842891,1040620,823349,809033,26472,490034,393851,221174,670979,668233,631396,209107,381357,258476,602337,58171,205334,477655,127915,523727,492296,450025,164637,825044,527623,550961,843382,743483,19697,27329,400453,112228,889949,894631,724623,304882,258766,67589,371958,26164,582198,777388,214036,559961,154486,228001,604802,52968,399191,605754,95925,411063,939486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]