SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38354 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38354 [ RunTime:0.006099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748149,1031283,38931,143257,1001754,811899,52434,543232,187059,103050,14012,786232,957689,900417,130156,641769,339353,898096,386167,720434,137597,673312,793128,311076,717369,114262,233291,1025299,440824,711098,107028,61000,338434,328579,195300,546085,20618,468255,32441,1038129,741643,28930,1028834,519158,161903,760552,690223,528130,789092,885770,161722,681108,435276,148248,78656,647450,998196,147583,491263,549512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]