SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381980 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381980 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179365,447184,1007397,248283,407107,111685,352949,262689,41664,988310,1023936,723953,528425,745077,593866,884966,527508,150176,332123,307031,208864,110093,748241,1035111,565852,250070,1011643,959325,684763,613202,689266,144391,991641,676246,172155,997938,734818,200598,887201,392718,415625,694958,572880,714552,16489,377506,195024,323131,435963,1039544,218818,737031,708880,802351,797553,915424,849860,991824,856560,558832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]