SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573840 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573840 [ RunTime:0.002379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132037,755358,810906,114457,158089,295280,1033256,269143,393018,194498,154007,571133,755208,446928,871706,375080,222970,526142,508857,717015,493392,664158,626633,409738,913420,450424,64769,70374,834247,596652,899563,213559,430555,190486,593264,129487,48588,349782,839499,763442,1043815,897440,648403,33349,460713,939118,802953,188943,768150,798306,983113,210070,151125,1025614,791924,551228,589534,42554,458524,380413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]