SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438198 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438198 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515037,216863,831785,235704,802807,837138,891394,1048347,879040,646967,718572,433024,15269,26602,364230,194218,195169,709278,24806,799441,108535,55504,536144,1012617,949892,333416,141401,437447,874139,986517,329042,686625,945564,1038560,826947,640747,690732,237945,739960,258438,471999,750936,704605,141207,746600,508499,103095,949163,1028409,87254,733942,255220,60403,579121,810250,952261,747079,242384,292662,118649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]