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` = 1006280 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006280 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204923,1039605,177324,792581,372224,165246,511697,883243,866507,840240,865826,36796,31952,523861,286179,712286,319479,940372,177701,787460,364321,558989,211987,1010167,276484,9450,317025,979934,651409,457518,220046,561867,716831,190785,341918,426770,638627,469554,608237,601267,368815,14500,954882,161015,239854,405504,467258,195202,783380,634087,687449,301467,770791,443455,497082,443342,296155,336432,620772,417433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]