SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505853 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505853 [ RunTime:0.002570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193010,795903,245432,480573,250487,444734,611895,127256,280972,623688,941534,709483,504568,554331,131857,28426,88616,480323,669470,37235,329655,93145,354265,248572,115430,629900,583303,848404,924995,97124,439569,796369,391732,146531,22385,134126,607167,448786,985812,1011183,914550,865459,512875,944941,59404,1002280,376514,161591,1705,194464,238463,743806,31257,659383,12418,26089,423238,357481,289576,509507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]