SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312001 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312001 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362050,836497,628811,163374,235008,824842,729094,428698,43992,580409,77988,333125,469790,922979,385333,162327,734810,59219,392297,51966,242496,225547,39101,207961,595160,533381,368238,162630,74451,367549,486098,361676,550114,367628,768528,471832,1021225,915355,400173,368104,58783,479469,509244,157721,701409,127915,911992,86297,237561,835369,907385,1036811,765295,808304,386116,108422,547517,958089,451700,678639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]