SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 131614 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 131614 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501671,747483,966353,4119,21312,498320,617408,260061,330639,716302,1007997,915494,830650,970578,891499,415847,949681,562368,1047671,138557,969937,193613,119408,50371,998722,540840,994161,836953,8779,295969,55077,929556,433869,424125,638823,844487,282453,405718,113722,187933,431389,786675,537498,323550,1026902,893956,771951,851874,167043,283014,393628,832131,196995,708859,647425,940406,723980,996851,348350,376108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 131614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 131614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]