SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504881 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504881 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268805,252583,623900,907410,734745,598044,559031,39655,911232,267219,152739,774964,55193,92672,471706,100621,936413,900069,493900,809015,54125,294387,175309,274267,529925,848596,164601,314586,805201,709676,1011576,981566,13822,521588,832507,701356,118144,23622,1012575,309713,940219,708631,919050,438031,1033690,1039872,1001988,56449,551938,953799,63665,667364,359323,578918,368132,1046907,910484,717694,336879,1035473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]