SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569873 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569873 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78,249579,373842,458453,389927,532900,629964,582997,946367,41976,21294,189718,915638,24,571200,1014200,704315,171484,981843,88376,940929,174846,910379,426826,783663,401817,740510,277930,109286,508690,462009,413199,441319,881953,733840,378027,867658,524327,59368,152120,76565,745297,926492,752434,803123,9843,1026365,821617,610917,956750,397122,397318,974036,846001,86148,415970,942696,656710,555784,695575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]