SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358823 LIMIT 1 [ RunTime:0.001692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358823 [ RunTime:0.002667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780650,395817,1026552,146710,1026676,129018,872839,353592,623022,453051,1020920,569656,150533,721731,372118,944306,424812,71781,328766,72737,378566,20778,490311,27114,184076,527579,917021,498859,294457,21838,670465,136898,44355,207910,574579,384096,375247,802798,871040,192755,437277,383708,312202,457215,170582,697382,772338,80728,672753,832746,450837,445140,215532,421660,581257,67253,866821,1038344,133345,130976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]