SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545617 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545617 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728544,182454,79580,620321,113134,607490,213934,686539,22439,106999,281106,413547,480753,471569,658665,720569,538689,204681,430217,188870,712125,786967,203881,169148,610016,370982,685890,729884,357394,414143,927567,998560,642927,513254,300168,790367,808489,461360,551213,918332,822813,807296,33495,703988,306324,275750,336907,673246,90763,142180,263760,598702,494851,488553,167070,342968,932158,669560,141069,249523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]