SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504600 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504600 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149705,556407,506498,18955,827974,259394,208176,23438,809661,611003,656800,202196,75904,157991,358381,629203,12964,495182,786868,999654,1046872,214997,243699,79815,547729,742542,622593,498547,393273,171401,976210,451482,1030239,704362,933902,946506,910772,863500,183496,656380,448053,917330,983567,99373,537078,322274,76395,720441,582145,438092,354120,518930,224381,423005,782470,220228,505359,424269,1043843,236129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]