SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503988 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503988 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499746,309878,421259,788755,994530,601846,1035258,527096,359082,233665,485466,115132,172207,507851,428402,514821,830211,267022,590548,751450,691346,577333,959460,94866,242344,594533,133435,730009,827647,176063,564696,23170,570538,715058,160971,842699,997256,835103,504802,296003,405831,930700,381131,782616,667643,1025422,175592,383497,896933,105028,87026,22438,65660,398886,402396,415967,97437,200417,79256,206569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]