SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540014 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540014 [ RunTime:0.002251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587355,36176,612784,950103,446032,588201,508865,504010,33060,255023,236094,574693,556675,607299,141906,93472,121498,1004726,633269,673522,741440,326923,658011,125657,971284,30203,993306,82846,373536,998919,339781,76792,594019,912362,216206,820416,407835,90918,197467,923991,828464,151634,126158,78942,789849,516361,767505,578880,770867,31269,702501,839308,482210,141809,844037,722229,365400,1009636,528114,293834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]