SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516144 LIMIT 1 [ RunTime:0.000673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516144 [ RunTime:0.003162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431069,642577,730458,669118,86655,849519,935997,574523,424263,582934,739776,133130,175439,273531,1040536,736913,538556,808798,134053,651754,376088,36446,711176,493944,1024697,345986,427276,332827,797127,454253,974050,377618,918196,6116,736714,966205,884555,587190,451644,436416,930948,574937,722170,160388,997845,630073,1041981,565513,602998,28168,625785,191102,71029,31545,668066,774501,330386,779726,789424,579921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001206s ]