SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396880 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396880 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217257,514405,262172,889505,545491,80775,568491,195954,174471,934265,379044,410196,96688,758661,542158,458045,119681,344466,519080,326776,759680,248215,330999,1040190,926251,119633,792139,667055,514749,115801,680928,591641,527935,478338,121012,911072,768525,142521,101619,518405,876831,677356,93440,1029494,649090,652683,60182,878983,992466,565661,409869,432976,597744,117190,603539,674641,427286,884841,64917,336451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]