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` = 246543 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246543 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964918,1011680,613117,345014,35095,182910,586468,533719,721159,481686,985747,741146,913222,418038,382724,623922,336990,810894,1030601,840537,276580,708592,455570,990514,748433,374741,778337,95155,167121,421410,371978,664413,796881,444705,942853,935868,568347,355091,557574,927604,568416,407380,207009,1017806,387794,931927,1022248,716558,464190,49972,262622,939418,1002747,538480,76929,888686,716534,503063,468802,240845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]