SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542864 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542864 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860830,854871,919850,1038880,983199,399426,859774,656762,129142,982550,375530,91846,17193,966603,895981,863148,652714,226028,194183,519012,953345,434212,652463,217839,711759,114006,432008,584100,860737,751798,907793,606104,982151,757694,396460,230443,10762,539822,146490,583843,427115,345609,508259,166526,354412,289329,302424,350183,503859,697986,947608,811062,1040950,665272,591885,962089,475688,461610,469874,30780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]