SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381206 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381206 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345260,413837,195319,906701,1036781,323505,855299,493553,159954,490377,476221,710338,959223,268146,125153,167579,678821,747809,609486,371841,533397,114440,346871,897534,200514,291583,666112,126333,879868,322340,98569,426153,876779,710180,955497,10741,920929,127323,874191,116248,321485,111872,391926,644844,46406,1000999,724252,285506,252304,168352,909600,164288,171926,931940,717654,964456,129882,805738,433820,692513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]