SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981612 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981612 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91000,981136,688785,93001,1016333,325226,147201,187266,854334,960153,826550,188621,418761,171924,583518,120856,53040,967049,203898,107188,182097,1013130,556140,688787,175222,1034157,329604,919928,293764,500656,26247,556976,698973,632232,544049,926785,287934,480608,754922,743628,265375,725290,839895,983443,385651,197666,519869,975126,558351,891331,128176,339101,834689,975655,552521,867067,782579,967750,36472,918610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]