SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010130 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010130 [ RunTime:0.001388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690605,93876,826028,846966,337456,640049,92475,325418,560887,668317,105012,912781,265269,786421,133655,108065,1026756,90569,813824,59942,1030092,220015,402052,747432,509399,803632,157685,656019,876419,208803,605202,950657,397105,401688,956956,840028,677557,1020872,228968,380328,719273,266525,927676,154147,394865,583071,745111,134822,104136,583642,102535,327856,644302,216657,1043712,229168,285523,702865,982545,669117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]