SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394943 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394943 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013854,345654,126407,623181,171423,713851,43962,299185,981576,1008966,621690,533100,788797,847593,26681,496955,562169,773790,591081,71273,467145,774356,195950,459767,749737,1437,49235,533684,372371,468324,913194,903883,244150,608074,629255,934493,162417,731511,522398,453699,142101,577232,870905,295754,465841,1013231,990598,624411,962110,1004560,499214,922136,976275,271298,953330,437109,193248,931645,20502,96759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]