SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 662017 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 662017 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128958,779042,533282,266007,649360,1008704,604188,878815,178388,579867,498123,908402,662573,16135,782859,937160,733280,276689,694487,210251,404859,874622,463574,432374,382243,680834,120502,747507,714962,106759,919500,437828,139473,580020,797098,521753,964109,856827,980153,968400,226159,488644,157513,373386,382103,280993,438128,162642,57022,809164,80879,1000170,422896,774582,464148,5826,571531,691659,1029324,934041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 662017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 662017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]