SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043538 LIMIT 1 [ RunTime:0.001651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043538 [ RunTime:0.003296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689675,44901,183151,705995,213289,111485,12309,716723,886039,196082,613715,861997,454503,150458,230040,655514,228315,590485,188382,498773,836647,527316,431478,405442,382374,430314,468609,882623,448963,25764,605176,368388,553442,798011,908888,893580,310583,373181,969796,599784,958426,458384,760074,962013,467343,484457,313612,10047,712275,503667,135507,222812,195777,72425,867123,124225,81482,32203,873698,805479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]