SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106721 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106721 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668091,552025,126999,78921,629084,279683,214007,702691,420977,649280,568552,455528,1036469,295608,571259,777509,982573,619680,842494,480372,743900,122092,486245,31991,194648,86557,245421,394885,950820,316160,527766,717108,1019950,32491,739645,823532,869806,947764,405282,515702,371507,863538,682379,399838,129735,743288,438507,49388,475423,182272,341698,728589,895110,1005124,1001964,91650,482088,635131,526920,363583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]