SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801596 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801596 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472838,627987,480587,650075,420919,601245,570478,555735,317471,860063,56825,941277,865389,538630,597028,568020,599229,163546,816394,168203,974400,98233,25193,583671,713944,359679,856435,887785,167043,917429,441474,738544,587255,274529,105346,371129,32615,294554,345233,923024,1016587,83416,952426,10728,506247,355300,589903,933672,235928,536392,1025305,142184,274767,574101,491737,714909,377776,874,430415,458036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]