SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445770 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445770 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354195,945518,561607,509923,1037665,663255,196884,251247,442671,997433,25397,83722,325444,931557,813530,870979,991546,410431,563142,752223,268887,96007,163793,836237,330543,122141,419510,359075,322878,88337,400980,712805,951424,720823,505177,989407,126806,606647,125973,569436,1041879,951441,929658,326683,563528,982510,583203,237282,726374,452118,707629,985818,143197,667522,1012564,205578,120022,935405,886238,913157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]