SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414699 LIMIT 1 [ RunTime:0.003047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414699 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334545,715255,696419,140798,696047,751032,590074,650186,470282,1044823,597104,224758,707804,839519,643505,127441,493277,564879,709920,882415,887349,351907,627734,319140,276200,27809,328855,689939,802838,176364,44268,466857,817896,381466,132838,343946,69436,272277,1012699,89753,95292,60630,354983,502848,501912,182088,516061,698955,97531,740864,533473,156976,91989,497671,772131,733353,1017602,1043915,55372,493382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.009078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]