SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282114 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282114 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023966,561598,112361,104533,358730,358107,336478,797492,413157,250937,949726,937658,988073,468595,18277,843029,373477,38550,684355,535393,860835,584632,944099,855312,344631,297018,247103,523006,40783,964098,88754,169691,911159,259800,313737,541100,115851,1011214,510946,114594,543378,405798,214785,70178,468286,924884,94048,382674,793234,274306,837835,731170,100419,1043227,26032,810722,873995,586252,531675,991441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001275s ]