SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391599 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391599 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431405,149555,615345,887053,745645,537724,384943,571645,108199,832260,279417,6658,785511,753134,326516,727109,1044806,200260,729885,577222,213437,799839,496367,995796,820847,606733,220753,110329,189901,830722,10043,474606,543633,597448,175441,572197,809049,621284,508753,353148,240871,378699,472575,647684,352253,592657,959773,283807,342038,11706,800700,860305,941940,544378,580159,624847,359749,805838,633945,412322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]