SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003923 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003923 [ RunTime:0.003285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854473,603727,531570,571758,129670,653343,80121,718257,1024447,911025,176124,933598,829119,919383,7190,282733,157210,751796,350309,389098,625926,373334,596472,49648,756769,964197,415188,283443,340417,865897,623257,290603,876136,973241,457875,265167,837964,691017,976935,732357,622111,683814,105413,740785,913258,760476,528644,372337,446674,1009328,387291,650887,621357,527015,387253,14588,542052,263720,942260,417857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]