SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49079 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49079 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614156,1660,1001424,124497,448394,971264,871118,284985,747138,164422,571086,795042,319918,422655,923000,1008050,668019,894376,98675,97221,989694,697440,762496,631619,392043,640199,825472,1044938,984628,79226,257379,270337,189068,646393,441712,1020755,411417,298843,88486,71375,1024547,805278,354682,945437,718395,560114,1030273,747305,35722,797715,621956,827868,546510,265325,90658,383760,1015200,153153,197036,62148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]